How to: Turn AutoFill off.
Solution:
Select 'Options...' from the 'Tools' menu and clear the 'Allow Cell Drag and Drop' check box.
1) Select the 'Tools' menu and select 'Options...'. (The Options dialog box appears.)
2) Click the 'Edit' tab.
3) Clear the 'Allow Cell Drag and Drop' check box in the 'Settings' group.
Unchecking the check box
4) Click 'OK'.